Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	13349
Missing cells	3952
Missing cells (%)	1.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.4 MiB
Average record size in memory	191.4 B

Variable types

Numeric	12
Categorical	5

Alerts

`Year` has constant value "2019"	Constant
`Duration` has a high cardinality: 373 distinct values	High cardinality
`Source` is highly correlated with `Destination`	High correlation
`Destination` is highly correlated with `Source`	High correlation
`Total_Stops` is highly correlated with `Price` and 1 other fields	High correlation
`Price` is highly correlated with `Total_Stops` and 1 other fields	High correlation
`duration_hour` is highly correlated with `Total_Stops` and 1 other fields	High correlation
`Source` is highly correlated with `Destination`	High correlation
`Destination` is highly correlated with `Source`	High correlation
`Total_Stops` is highly correlated with `Price` and 1 other fields	High correlation
`Price` is highly correlated with `Total_Stops` and 1 other fields	High correlation
`duration_hour` is highly correlated with `Total_Stops` and 1 other fields	High correlation
`Source` is highly correlated with `Destination`	High correlation
`Destination` is highly correlated with `Source`	High correlation
`Total_Stops` is highly correlated with `Price` and 1 other fields	High correlation
`Price` is highly correlated with `Total_Stops` and 1 other fields	High correlation
`duration_hour` is highly correlated with `Total_Stops` and 1 other fields	High correlation
`Source` is highly correlated with `Year`	High correlation
`Month` is highly correlated with `Year`	High correlation
`Total_Stops` is highly correlated with `Year`	High correlation
`Year` is highly correlated with `Source` and 2 other fields	High correlation
`Airline` is highly correlated with `Source` and 6 other fields	High correlation
`Source` is highly correlated with `Airline` and 4 other fields	High correlation
`Destination` is highly correlated with `Source` and 3 other fields	High correlation
`Total_Stops` is highly correlated with `Airline` and 3 other fields	High correlation
`Additional_Info` is highly correlated with `Airline` and 1 other fields	High correlation
`Price` is highly correlated with `Airline` and 1 other fields	High correlation
`Month` is highly correlated with `Destination`	High correlation
`Arrival_hour` is highly correlated with `Airline` and 2 other fields	High correlation
`Arrival_min` is highly correlated with `Airline` and 1 other fields	High correlation
`Dept_hour` is highly correlated with `Arrival_hour`	High correlation
`duration_hour` is highly correlated with `Airline` and 3 other fields	High correlation
`duration_min` is highly correlated with `Source`	High correlation
`Price` has 2669 (20.0%) missing values	Missing
`duration_min` has 1282 (9.6%) missing values	Missing
`Airline` has 405 (3.0%) zeros	Zeros
`Destination` has 3581 (26.8%) zeros	Zeros
`Arrival_hour` has 411 (3.1%) zeros	Zeros
`Arrival_min` has 1827 (13.7%) zeros	Zeros
`Dept_min` has 2590 (19.4%) zeros	Zeros

Reproduction

Analysis started	2022-04-11 08:41:45.420689
Analysis finished	2022-04-11 08:42:38.663796
Duration	53.24 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

Distinct	10680
Distinct (%)	80.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4540.556596

Minimum	0
Maximum	10682
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	104.4 KiB

Quantile statistics

Minimum	0
5-th percentile	334.4
Q1	1669
median	4007
Q3	7345
95-th percentile	10014.6
Maximum	10682
Range	10682
Interquartile range (IQR)	5676

Descriptive statistics

Standard deviation	3208.701447
Coefficient of variation (CV)	0.7066757962
Kurtosis	-1.22238653
Mean	4540.556596
Median Absolute Deviation (MAD)	2671
Skewness	0.3320458831
Sum	60611890
Variance	10295764.98
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2	< 0.1%
1774	2	< 0.1%
1776	2	< 0.1%
1777	2	< 0.1%
1778	2	< 0.1%
1779	2	< 0.1%
1780	2	< 0.1%
1781	2	< 0.1%
1782	2	< 0.1%
1783	2	< 0.1%
Other values (10670)	13329	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	2	< 0.1%
3	2	< 0.1%
4	2	< 0.1%
5	2	< 0.1%
6	2	< 0.1%
7	2	< 0.1%
8	2	< 0.1%
9	2	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
10682	1	< 0.1%
10681	1	< 0.1%
10680	1	< 0.1%
10679	1	< 0.1%
10678	1	< 0.1%
10677	1	< 0.1%
10676	1	< 0.1%
10675	1	< 0.1%
10674	1	< 0.1%
10673	1	< 0.1%

Airline
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.977526406

Minimum	0
Maximum	11
Zeros	405
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	4
Q3	4
95-th percentile	8
Maximum	11
Range	11
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.364158661
Coefficient of variation (CV)	0.5943791239
Kurtosis	0.3292713726
Mean	3.977526406
Median Absolute Deviation (MAD)	1
Skewness	0.7207852624
Sum	53096
Variance	5.589246173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
4	4743	35.5%
3	2564	19.2%
1	2190	16.4%
6	1543	11.6%
8	1026	7.7%
10	608	4.6%
0	405	3.0%
2	240	1.8%
7	16	0.1%
5	8	0.1%
Other values (2)	6	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	405	3.0%
1	2190	16.4%
2	240	1.8%
3	2564	19.2%
4	4743	35.5%
5	8	0.1%
6	1543	11.6%
7	16	0.1%
8	1026	7.7%
9	1	< 0.1%

Value	Count	Frequency (%)
11	5	< 0.1%
10	608	4.6%
9	1	< 0.1%
8	1026	7.7%
7	16	0.1%
6	1543	11.6%
5	8	0.1%
4	4743	35.5%
3	2564	19.2%
2	240	1.8%

Source
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	756.2 KiB

2	5679
3	3581
0	2752
4	881
1	456

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	3
3rd row	3
4th row	0
5th row	3

Common Values

Value	Count	Frequency (%)
2	5679	42.5%
3	3581	26.8%
0	2752	20.6%
4	881	6.6%
1	456	3.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2	5679	42.5%
3	3581	26.8%
0	2752	20.6%
4	881	6.6%
1	456	3.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Destination
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.435313507

Minimum	0
Maximum	5
Zeros	3581
Zeros (%)	26.8%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.473504718
Coefficient of variation (CV)	1.026608271
Kurtosis	0.6480054839
Mean	1.435313507
Median Absolute Deviation (MAD)	1
Skewness	1.248116424
Sum	19160
Variance	2.171216153
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	5679	42.5%
0	3581	26.8%
2	1582	11.9%
5	1170	8.8%
3	881	6.6%
4	456	3.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3581	26.8%
1	5679	42.5%
2	1582	11.9%
3	881	6.6%
4	456	3.4%
5	1170	8.8%

Value	Count	Frequency (%)
5	1170	8.8%
4	456	3.4%
3	881	6.6%
2	1582	11.9%
1	5679	42.5%
0	3581	26.8%

Duration
Categorical

HIGH CARDINALITY

Distinct	373
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Memory size	821.5 KiB

2h 50m	672
1h 30m	493
2h 45m	432
2h 55m	418
2h 35m	399
Other values (368)	10935

Length

Max length	7
Median length	6
Mean length	6.004869279
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	0.2%

Sample

1st row	2h 50m
2nd row	7h 25m
3rd row	5h 25m
4th row	4h 45m
5th row	2h 25m

Common Values

Value	Count	Frequency (%)
2h 50m	672	5.0%
1h 30m	493	3.7%
2h 45m	432	3.2%
2h 55m	418	3.1%
2h 35m	399	3.0%
3h	333	2.5%
2h 20m	286	2.1%
2h 30m	278	2.1%
2h 40m	196	1.5%
2h 15m	164	1.2%
Other values (363)	9678	72.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2h	2967	11.7%
30m	1818	7.2%
20m	1260	5.0%
50m	1205	4.7%
45m	1153	4.5%
35m	1149	4.5%
15m	1135	4.5%
55m	1121	4.4%
25m	1009	4.0%
40m	803	3.2%
Other values (44)	11796	46.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Total_Stops
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	782.3 KiB

1.0	7055
0.0	4340
2.0	1895
3.0	56
4.0	2

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	2.0
3rd row	1.0
4th row	1.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
1.0	7055	52.9%
0.0	4340	32.5%
2.0	1895	14.2%
3.0	56	0.4%
4.0	2	< 0.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	7055	52.9%
0.0	4340	32.5%
2.0	1895	14.2%
3.0	56	0.4%
4.0	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Additional_Info
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.407745899

Minimum	0
Maximum	9
Zeros	20
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	8
median	8
Q3	8
95-th percentile	8
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.198391911
Coefficient of variation (CV)	0.1617755155
Kurtosis	2.397648133
Mean	7.407745899
Median Absolute Deviation (MAD)	0
Skewness	-1.784859053
Sum	98886
Variance	1.436143173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
8	10489	78.6%
5	2425	18.2%
7	396	3.0%
0	20	0.1%
4	8	0.1%
3	5	< 0.1%
6	3	< 0.1%
1	1	< 0.1%
9	1	< 0.1%
2	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	20	0.1%
1	1	< 0.1%
2	1	< 0.1%
3	5	< 0.1%
4	8	0.1%
5	2425	18.2%
6	3	< 0.1%
7	396	3.0%
8	10489	78.6%
9	1	< 0.1%

Value	Count	Frequency (%)
9	1	< 0.1%
8	10489	78.6%
7	396	3.0%
6	3	< 0.1%
5	2425	18.2%
4	8	0.1%
3	5	< 0.1%
2	1	< 0.1%
1	1	< 0.1%
0	20	0.1%

Price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	1870
Distinct (%)	17.5%
Missing	2669
Missing (%)	20.0%
Infinite	0
Infinite (%)	0.0%
Mean	9085.449906

Minimum	1759
Maximum	79512
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	104.4 KiB

Quantile statistics

Minimum	1759
5-th percentile	3543
Q1	5277
median	8372
Q3	12373
95-th percentile	15764
Maximum	79512
Range	77753
Interquartile range (IQR)	7096

Descriptive statistics

Standard deviation	4610.904239
Coefficient of variation (CV)	0.5075042278
Kurtosis	13.3157598
Mean	9085.449906
Median Absolute Deviation (MAD)	3382
Skewness	1.813937941
Sum	97032605
Variance	21260437.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10262	258	1.9%
10844	212	1.6%
7229	162	1.2%
4804	160	1.2%
4823	131	1.0%
14714	109	0.8%
3943	104	0.8%
15129	93	0.7%
3841	91	0.7%
12898	86	0.6%
Other values (1860)	9274	69.5%
(Missing)	2669	20.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1759	4	< 0.1%
1840	1	< 0.1%
1965	36	0.3%
2017	35	0.3%
2050	10	0.1%
2071	6	< 0.1%
2175	7	0.1%
2227	40	0.3%
2228	9	0.1%
2385	6	< 0.1%

Value	Count	Frequency (%)
79512	1	< 0.1%
62427	1	< 0.1%
57209	1	< 0.1%
54826	3	< 0.1%
52285	1	< 0.1%
52229	1	< 0.1%
46490	1	< 0.1%
36983	1	< 0.1%
36235	2	< 0.1%
35185	1	< 0.1%

Date
Real number (ℝ_≥0)

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.39036632

Minimum	1
Maximum	27
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	6
median	12
Q3	21
95-th percentile	27
Maximum	27
Range	26
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.44003865
Coefficient of variation (CV)	0.6303067779
Kurtosis	-1.25973729
Mean	13.39036632
Median Absolute Deviation (MAD)	6
Skewness	0.1349670303
Sum	178748
Variance	71.23425241
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
9	1768	13.2%
6	1626	12.2%
21	1367	10.2%
27	1350	10.1%
1	1349	10.1%
24	1307	9.8%
15	1251	9.4%
12	1212	9.1%
3	1083	8.1%
18	1036	7.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1349	10.1%
3	1083	8.1%
6	1626	12.2%
9	1768	13.2%
12	1212	9.1%
15	1251	9.4%
18	1036	7.8%
21	1367	10.2%
24	1307	9.8%
27	1350	10.1%

Value	Count	Frequency (%)
27	1350	10.1%
24	1307	9.8%
21	1367	10.2%
18	1036	7.8%
15	1251	9.4%
12	1212	9.1%
9	1768	13.2%
6	1626	12.2%
3	1083	8.1%
1	1349	10.1%

Month
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	756.2 KiB

5	4328
6	4284
3	3410
4	1327

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	5
3rd row	5
4th row	3
5th row	6

Common Values

Value	Count	Frequency (%)
5	4328	32.4%
6	4284	32.1%
3	3410	25.5%
4	1327	9.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
5	4328	32.4%
6	4284	32.1%
3	3410	25.5%
4	1327	9.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Year
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	795.3 KiB

2019	13349

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2019
2nd row	2019
3rd row	2019
4th row	2019
5th row	2019

Common Values

Value	Count	Frequency (%)
2019	13349	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2019	13349	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Arrival_hour
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	24
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.39605963

Minimum	0
Maximum	23
Zeros	411
Zeros (%)	3.1%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	8
median	14
Q3	19
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.896702582
Coefficient of variation (CV)	0.5148306869
Kurtosis	-1.077425526
Mean	13.39605963
Median Absolute Deviation (MAD)	5
Skewness	-0.3844995427
Sum	178824
Variance	47.5645065
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
19	2056	15.4%
12	1094	8.2%
4	1012	7.6%
21	898	6.7%
22	837	6.3%
1	688	5.2%
18	640	4.8%
23	608	4.6%
8	594	4.4%
10	593	4.4%
Other values (14)	4329	32.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	411	3.1%
1	688	5.2%
2	92	0.7%
3	61	0.5%
4	1012	7.6%
5	95	0.7%
6	64	0.5%
7	518	3.9%
8	594	4.4%
9	591	4.4%

Value	Count	Frequency (%)
23	608	4.6%
22	837	6.3%
21	898	6.7%
20	489	3.7%
19	2056	15.4%
18	640	4.8%
17	242	1.8%
16	447	3.3%
15	222	1.7%
14	360	2.7%

Arrival_min
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.66064874

Minimum	0
Maximum	55
Zeros	1827
Zeros (%)	13.7%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	25
Q3	35
95-th percentile	50
Maximum	55
Range	55
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	16.5570425
Coefficient of variation (CV)	0.6713952529
Kurtosis	-1.038536052
Mean	24.66064874
Median Absolute Deviation (MAD)	10
Skewness	0.1117482913
Sum	329195
Variance	274.1356562
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	1827	13.7%
15	1612	12.1%
25	1598	12.0%
35	1364	10.2%
20	1106	8.3%
30	1062	8.0%
50	935	7.0%
45	889	6.7%
5	839	6.3%
40	785	5.9%
Other values (2)	1332	10.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1827	13.7%
5	839	6.3%
10	717	5.4%
15	1612	12.1%
20	1106	8.3%
25	1598	12.0%
30	1062	8.0%
35	1364	10.2%
40	785	5.9%
45	889	6.7%

Value	Count	Frequency (%)
55	615	4.6%
50	935	7.0%
45	889	6.7%
40	785	5.9%
35	1364	10.2%
30	1062	8.0%
25	1598	12.0%
20	1106	8.3%
15	1612	12.1%
10	717	5.4%

Dept_hour
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	24
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.51277249

Minimum	0
Maximum	23
Zeros	51
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	8
median	11
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	5.736752484
Coefficient of variation (CV)	0.4584717326
Kurtosis	-1.197785085
Mean	12.51277249
Median Absolute Deviation (MAD)	5
Skewness	0.1092454768
Sum	167033
Variance	32.91032906
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
9	1150	8.6%
7	1067	8.0%
8	872	6.5%
6	863	6.5%
17	847	6.3%
20	826	6.2%
5	776	5.8%
11	714	5.3%
19	709	5.3%
10	677	5.1%
Other values (14)	4848	36.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	51	0.4%
1	44	0.3%
2	228	1.7%
3	30	0.2%
4	219	1.6%
5	776	5.8%
6	863	6.5%
7	1067	8.0%
8	872	6.5%
9	1150	8.6%

Value	Count	Frequency (%)
23	189	1.4%
22	486	3.6%
21	625	4.7%
20	826	6.2%
19	709	5.3%
18	553	4.1%
17	847	6.3%
16	602	4.5%
15	431	3.2%
14	647	4.8%

Dept_min
Real number (ℝ_≥0)

ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.50333358

Minimum	0
Maximum	55
Zeros	2590
Zeros (%)	19.4%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	25
Q3	40
95-th percentile	55
Maximum	55
Range	55
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	18.8329269
Coefficient of variation (CV)	0.7685863164
Kurtosis	-1.304691908
Mean	24.50333358
Median Absolute Deviation (MAD)	20
Skewness	0.1596940484
Sum	327095
Variance	354.6791356
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	2590	19.4%
30	1491	11.2%
55	1332	10.0%
45	1106	8.3%
10	1099	8.2%
5	951	7.1%
15	875	6.6%
25	863	6.5%
20	819	6.1%
35	812	6.1%
Other values (2)	1411	10.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2590	19.4%
5	951	7.1%
10	1099	8.2%
15	875	6.6%
20	819	6.1%
25	863	6.5%
30	1491	11.2%
35	812	6.1%
40	646	4.8%
45	1106	8.3%

Value	Count	Frequency (%)
55	1332	10.0%
50	765	5.7%
45	1106	8.3%
40	646	4.8%
35	812	6.1%
30	1491	11.2%
25	863	6.5%
20	819	6.1%
15	875	6.6%
10	1099	8.2%

duration_hour
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	43
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.23335081

Minimum	1
Maximum	47
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	52.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	8
Q3	15
95-th percentile	26
Maximum	47
Range	46
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	8.472646818
Coefficient of variation (CV)	0.8279445289
Kurtosis	-0.144615562
Mean	10.23335081
Median Absolute Deviation (MAD)	6
Skewness	0.8580624796
Sum	136605
Variance	71.7857441
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
2	2967	22.2%
1	785	5.9%
3	627	4.7%
5	608	4.6%
7	600	4.5%
9	551	4.1%
12	538	4.0%
8	531	4.0%
13	516	3.9%
11	467	3.5%
Other values (33)	5159	38.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	785	5.9%
2	2967	22.2%
3	627	4.7%
4	278	2.1%
5	608	4.6%
6	442	3.3%
7	600	4.5%
8	531	4.0%
9	551	4.1%
10	459	3.4%

Value	Count	Frequency (%)
47	2	< 0.1%
42	2	< 0.1%
41	1	< 0.1%
40	2	< 0.1%
39	3	< 0.1%
38	41	0.3%
37	22	0.2%
36	11	0.1%
35	10	0.1%
34	9	0.1%

duration_min
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	11
Distinct (%)	0.1%
Missing	1282
Missing (%)	9.6%
Infinite	0
Infinite (%)	0.0%
Mean	31.35990718

Minimum	5
Maximum	55
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	104.4 KiB

Quantile statistics

Minimum	5
5-th percentile	5
Q1	20
median	30
Q3	45
95-th percentile	55
Maximum	55
Range	50
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	14.88542329
Coefficient of variation (CV)	0.4746641373
Kurtosis	-1.059999682
Mean	31.35990718
Median Absolute Deviation (MAD)	10
Skewness	-0.03320228296
Sum	378420
Variance	221.5758265
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
30	1818	13.6%
20	1260	9.4%
50	1205	9.0%
45	1153	8.6%
35	1149	8.6%
15	1135	8.5%
55	1121	8.4%
25	1009	7.6%
40	803	6.0%
5	767	5.7%
(Missing)	1282	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	767	5.7%
10	647	4.8%
15	1135	8.5%
20	1260	9.4%
25	1009	7.6%
30	1818	13.6%
35	1149	8.6%
40	803	6.0%
45	1153	8.6%
50	1205	9.0%

Value	Count	Frequency (%)
55	1121	8.4%
50	1205	9.0%
45	1153	8.6%
40	803	6.0%
35	1149	8.6%
30	1818	13.6%
25	1009	7.6%
20	1260	9.4%
15	1135	8.5%
10	647	4.8%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	Airline	Source	Destination	Duration	Total_Stops	Additional_Info	Price	Date	Month	Year	Arrival_hour	Arrival_min	Dept_hour	Dept_min	duration_hour	duration_min
0	0	3	0	5	2h 50m	0.0	8	3897.0	24	3	2019	1	10	22	20	2	50
1	1	1	3	0	7h 25m	2.0	8	7662.0	1	5	2019	13	15	5	50	7	25
2	3	3	3	0	5h 25m	1.0	8	6218.0	12	5	2019	23	30	18	5	5	25
3	4	3	0	5	4h 45m	1.0	8	13302.0	1	3	2019	21	35	16	50	4	45
4	5	8	3	0	2h 25m	0.0	8	3873.0	24	6	2019	11	25	9	0	2	25
5	6	4	0	5	15h 30m	1.0	5	11087.0	12	3	2019	10	25	18	55	15	30
6	7	4	0	5	21h 5m	1.0	8	22270.0	1	3	2019	5	5	8	0	21	5
7	8	4	0	5	25h 30m	1.0	5	11087.0	12	3	2019	10	25	8	55	25	30
8	9	6	2	1	7h 50m	1.0	8	8625.0	27	5	2019	19	15	11	25	7	50
9	10	1	2	1	13h 15m	1.0	8	8907.0	1	6	2019	23	0	9	45	13	15

Last rows

	df_index	Airline	Source	Destination	Duration	Total_Stops	Additional_Info	Price	Date	Month	Year	Arrival_hour	Arrival_min	Dept_hour	Dept_min	duration_hour	duration_min
13339	2661	4	2	1	33h 15m	2.0	8	NaN	27	3	2019	4	25	19	10	33	15
13340	2662	1	4	3	1h 30m	0.0	8	NaN	21	5	2019	15	25	13	55	1	30
13341	2663	2	3	0	8h 15m	1.0	8	NaN	12	5	2019	7	45	23	30	8	15
13342	2664	6	2	1	10h 15m	1.0	8	NaN	15	6	2019	1	30	15	15	10	15
13343	2665	8	4	3	1h 30m	0.0	7	NaN	21	6	2019	0	15	22	45	1	30
13344	2666	1	3	0	23h 55m	1.0	8	NaN	6	6	2019	20	25	20	30	23	55
13345	2667	3	3	0	2h 35m	0.0	8	NaN	27	3	2019	16	55	14	20	2	35
13346	2668	4	2	1	6h 35m	1.0	8	NaN	6	3	2019	4	25	21	50	6	35
13347	2669	1	2	1	15h 15m	1.0	8	NaN	6	3	2019	19	15	4	0	15	15
13348	2670	6	2	1	14h 20m	1.0	8	NaN	15	6	2019	19	15	4	55	14	20

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows